package DB.Controle;

/**
 *
 * @author pgrabin
 */
public abstract class ControleTable {
    
    private static final String INT_TYPE = " INT";
    private static final String NOT_NULL = " NOT NULL ";
    private static final String COMMA_SEP = ", ";
    
    public static final String TABLE_NAME = "controle";
    
    public static final String COLUMN_ID = "id";
    public static final String COLUMN_USERID = "userID";
    
    public static final String TABLE_CREATE =
            "CREATE TABLE IF NOT EXISTS " + TABLE_NAME + "("
            + COLUMN_ID + " INTEGER CONSTRAINT 'index_controle' PRIMARY KEY ON CONFLICT REPLACE AUTOINCREMENT" + NOT_NULL + COMMA_SEP
            + COLUMN_USERID + INT_TYPE + NOT_NULL + ");";
    
    public static final String DELETE_ALL = "DELETE FROM " + TABLE_NAME;
}
